*** README FILE
*** Police Presence, Rapid Response Rates, and Crime Prevention
*** by Sarit Weisburd
*** Tel Aviv University
*** Published in the Review of Economics and Statistics

 
1. Data access: 2009 DPD AVL Data, 2009 DPD 911 Call Data, 2009 DPD Arrest Data, 2008 Reporting Areas 

The AVL data provides information on the location and assignment of DPD emergency vehicles, the Call data provides records of 911 calls, the Arrest data provides records of arrests, the Reporting Areas data
provides a record of each DPD reporting area including it's beat, sector, division, size in acres, and population.

The data used in the analysis was provided by the Police Foundation. The important steps for access are:

a. Researchers can gain access to the data by submitting a written application to the police foundation. 
b. Data access is given to researchers affiliated with an officially approved research institution/university, based on application. 
c. The application should include a detailed research proposal describing the goals and methods of the project, a detailed list of variables, the selection criteria to be used, how the research will be funded, and how the anonymity of all subjects in the data will be preserved.
d. The application should be submitted to Karen Amendola (kamendola@policefoundation.org)

2. Data access: a dbf/shape file of Dallas Police Department reporting areas and beats in 2008 and 2009

This data is necessary in order to match the AVL data to beats as the source data is geo-coded.

a. Researchers can gain accesss to the data by submitting a request to City of Dallas Open Records (https://dallascityhall.com/government/citysecretary/openrecords/Pages/default.aspx)

3. Data access: Dallas weather data (weather_in.csv)

a. This data includes daily weather characteristics for Dallas in 2009

4. Data access: A list of 2009 Dallas beats (beats_2009.csv)

5. Data access: Dallas characteristics by 2008 reporting area (income.csv)   

a. this data was downloaded from census.gov and mapped to reporting areas. 

6. Programs

The code for generating the micro data used in the present study and generating regression results is summarized in the accompanying stata do-file MS21899_master_do_file.txt which calls the following stata do files:
a. create_calls_by_beat.txt
b. transition_matrix.txt
c. create_data.txt
d. create_figures.txt
e. table1.txt
f. table2.txt
g. table3.txt
h. binary_table3.txt
i. table4.txt
j. table5.txt
k. table6.txt
l. table7.txt
m. table8.txt

7. Variables:
a. crime_count - number of crimes occurring 
b. c_violence - number of violent crimes occurring 
c. c_disturbance - number of public disturbances occurring 
d. c_theft - number of thefts occurring
e. c_burglary - number of burglaries occurring
f. arrest - number of arrests occurring
g. stat_not_call_hour-fraction of hour for which police are located in this beat
h. out_unrelated- number of outside calls an officer at this beat is expected to be assigned to in this hour 
i. out_unrelated_r - out_unrelated/(officer availability at sectors surrounding beats where outside calls took place this hour)
j. hightemp - daily temperature
k. precipitation_cm - daily precipitation
l. twilight - dummy variable of 1 if twilight hour 
m. holiday - dummy of 1 if holiday 
n. dark - dummy of 1 if dark 
o. beat - defines location
p. day - date
q. hour - hour of day
r. x,y - latitude longitude coordinates for center of beat 
s. c - hour counter equal to 1 at first hour beat is observed 

